package com.xh.test;

import com.aspose.cells.Cells;
import com.aspose.cells.Workbook;
import com.xh.core.util.OfficeUtils;

import java.io.*;
import java.net.HttpURLConnection;
import java.net.URL;
import java.util.ArrayList;
import java.util.List;

public class DownFileUtils {
    /**
     * 从网络Url中下载文件
     *
     * @param urlStr
     * @param fileName
     * @param savePath
     * @throws IOException
     */
    public static void downLoadFromUrl(String urlStr, String fileName, String savePath) throws IOException {


        //得到输入流
        InputStream inputStream = null;
        try {
            URL url = new URL(urlStr);
            HttpURLConnection conn = (HttpURLConnection) url.openConnection();
            //设置超时间为3秒
            conn.setConnectTimeout(3 * 1000);
            //防止屏蔽程序抓取而返回403错误
            conn.setRequestProperty("User-Agent", "Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)");
            inputStream = conn.getInputStream();
            //获取自己数组
            byte[] getData = readInputStream(inputStream);

            //文件保存位置
            File saveDir = new File(savePath);
            if (!saveDir.exists()) {
                saveDir.mkdir();
            }
            File file = new File(saveDir + File.separator + fileName);
            FileOutputStream fos = new FileOutputStream(file);
            fos.write(getData);
            if (fos != null) {
                fos.close();
            }
            if (inputStream != null) {
                inputStream.close();
            }
        } catch (IOException e) {
            e.printStackTrace();
        }

//        System.out.println("info:" + url + " download success");

    }


    /**
     * 从输入流中获取字节数组
     *
     * @param inputStream
     * @return
     * @throws IOException
     */
    public static byte[] readInputStream(InputStream inputStream) throws IOException {
        byte[] buffer = new byte[1024];
        int len = 0;
        ByteArrayOutputStream bos = new ByteArrayOutputStream();
        while ((len = inputStream.read(buffer)) != -1) {
            bos.write(buffer, 0, len);
        }
        bos.close();
        return bos.toByteArray();
    }

    public static List<String> getExcel() throws Exception {
        List<String> list = new ArrayList<>();
        com.aspose.cells.Workbook book = new com.aspose.cells.Workbook("d:/mp4.xlsx");
        Cells cells = book.getWorksheets().get(0).getCells();
        for (int i = 0; i < cells.getMaxRow() + 1; i++) {
            for (int j = 0; j < cells.getMaxColumn() + 1; j++) {
                String s = cells.get(i, j).getStringValue().trim();
                if("gsCover".equals(s)){
                    continue;
                }
                list.add("https://www.zhangfaedu.com/jyShop/"+s);
            }
        }
        return list;
    }

    public static void main(String[] args) throws Exception {
        List<String> result = getExcel();
        for (String url : result) {
            String savePath = url.substring(url.lastIndexOf("/") + 1);
            System.out.println(savePath);
            try {
                downLoadFromUrl(url,
                        savePath, "d:/upload/lessonResource/");
            } catch (Exception e) {
                // TODO: handle exception
            }
        }

    }
}
